Tabela LInvoicePosition

Definicja tabeli LInvoicePosition

Name

LInvoicePosition

Code

LInvoicePosition

Comment

 


Lista kolumn tabeli LInvoicePosition

Name

Code

InvoiceID

InvoiceID

ContractServID

ContractServID

FullName

FullName

VATRate

VATRate

UnitPrice

UnitPrice

PositionNumber

PositionNumber

PatientSurcharge

PatientSurcharge

ContractedNumberOfProducts

ContractedNumberOfProducts

ContractedProductUnitRate

ContractedProductUnitRate

ContractedMaxWorth

ContractedMaxWorth

MonthNumberToAccount

MonthNumberToAccount

MonthWorthToAccount

MonthWorthToAccount

IncreasingRealizationPlan

IncreasingRealizationPlan

IncreasingExecutedNumber

IncreasingExecutedNumber

IncreasingExecutedWorth

IncreasingExecutedWorth

UnitsCount

UnitsCount

isPrint

isPrint


Kolumna InvoiceID tabeli LInvoicePosition

Definicja kolumny InvoiceID tabeli LInvoicePosition

Name

InvoiceID

Code

InvoiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractServID tabeli LInvoicePosition

Definicja kolumny ContractServID tabeli LInvoicePosition

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FullName tabeli LInvoicePosition

Definicja kolumny FullName tabeli LInvoicePosition

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna VATRate tabeli LInvoicePosition

Definicja kolumny VATRate tabeli LInvoicePosition

Name

VATRate

Code

VATRate

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna UnitPrice tabeli LInvoicePosition

Definicja kolumny UnitPrice tabeli LInvoicePosition

Name

UnitPrice

Code

UnitPrice

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Kolumna PositionNumber tabeli LInvoicePosition

Definicja kolumny PositionNumber tabeli LInvoicePosition

Name

PositionNumber

Code

PositionNumber

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientSurcharge tabeli LInvoicePosition

Definicja kolumny PatientSurcharge tabeli LInvoicePosition

Name

PatientSurcharge

Code

PatientSurcharge

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna ContractedNumberOfProducts tabeli LInvoicePosition

Definicja kolumny ContractedNumberOfProducts tabeli LInvoicePosition

Name

ContractedNumberOfProducts

Code

ContractedNumberOfProducts

Data Type

NUMBER(14,4)

Mandatory

No

Comment

 


Kolumna ContractedProductUnitRate tabeli LInvoicePosition

Definicja kolumny ContractedProductUnitRate tabeli LInvoicePosition

Name

ContractedProductUnitRate

Code

ContractedProductUnitRate

Data Type

NUMBER(14,4)

Mandatory

No

Comment

 


Kolumna ContractedMaxWorth tabeli LInvoicePosition

Definicja kolumny ContractedMaxWorth tabeli LInvoicePosition

Name

ContractedMaxWorth

Code

ContractedMaxWorth

Data Type

NUMBER(14,2)

Mandatory

No

Comment

 


Kolumna MonthNumberToAccount tabeli LInvoicePosition

Definicja kolumny MonthNumberToAccount tabeli LInvoicePosition

Name

MonthNumberToAccount

Code

MonthNumberToAccount

Data Type

NUMBER(14,4)

Mandatory

No

Comment

 


Kolumna MonthWorthToAccount tabeli LInvoicePosition

Definicja kolumny MonthWorthToAccount tabeli LInvoicePosition

Name

MonthWorthToAccount

Code

MonthWorthToAccount

Data Type

NUMBER(14,2)

Mandatory

No

Comment

 


Kolumna IncreasingRealizationPlan tabeli LInvoicePosition

Definicja kolumny IncreasingRealizationPlan tabeli LInvoicePosition

Name

IncreasingRealizationPlan

Code

IncreasingRealizationPlan

Data Type

NUMBER(14,4)

Mandatory

No

Comment

 


Kolumna IncreasingExecutedNumber tabeli LInvoicePosition

Definicja kolumny IncreasingExecutedNumber tabeli LInvoicePosition

Name

IncreasingExecutedNumber

Code

IncreasingExecutedNumber

Data Type

NUMBER(14,4)

Mandatory

No

Comment

 


Kolumna IncreasingExecutedWorth tabeli LInvoicePosition

Definicja kolumny IncreasingExecutedWorth tabeli LInvoicePosition

Name

IncreasingExecutedWorth

Code

IncreasingExecutedWorth

Data Type

NUMBER(14,2)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli LInvoicePosition

Definicja kolumny UnitsCount tabeli LInvoicePosition

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(16,4)

Mandatory

No

Comment

 


Kolumna isPrint tabeli LInvoicePosition

Definicja kolumny isPrint tabeli LInvoicePosition

Name

isPrint

Code

isPrint

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli LInvoicePosition

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LInvoicePosition

Definicja klucza Identifier_1 tabeli LInvoicePosition

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment